
TTS-843 Changes to Ticket Types "Tech Support" and "Service"
------------------------------------------------------------------

take masterdata tables backup

 update [MasterData].[TicketTopic] set tickettypeid=6 where tickettopicid=25
 update [MasterData].[TicketTopic] set tickettypeid=5 where tickettopicid in(30,31,32,33,34,35,36,37)
 update [MasterData].[TicketTopic] set IsActive=0 where tickettopicid=29

update tickettype in ticketheader table for previous service tickets



TTS-846 Add a White Button to the "Contact Information"
-------------------------------------------------------------

ALTER TABLE [TroxlerTS_DEV].[TTS].[TicketHeader] ADD isVerifiedContact BIT DEFAULT 0 NOT NULL

[dbo].[uspInsertTicketTest]
[TTS].[uspGetTicketDetailsTest]
[TTS].[uspUpdateTicket]






